AVERAGE3D

Returns the average (arithmetic mean) of all the numbers in a range of cells in the whole workbook.

For example, you can use AVERAGE3D to return the average of the numbers in a given range in the whole workbook. You just need to specify a range, and AVERAGE3D will go through the same range in all worksheets in the workbook and find out the answer for you.

AVERAGE3D is very similar to the AVERAGE function of Microsoft Excel. The main difference is that AVERAGE3D considers all worksheets, while the original AVERAGE function doesn't.

Syntax

AVERAGE3D(range_input, include_current)

range_input - is the range for which you want to determine the average.

include_current - Optional. Boolean argument , either TRUE or FALSE. Decides whether the current worksheet is included in the function's consideration. TRUE means the current worksheet will be considered, and vice versa.

Range(s) that include error values or text that cannot be translated into numbers cause errors.

Tip

When averaging cells, keep in mind the difference between empty cells and those containing the
value zero, especially if you have cleared the Zero values check box on the View tab (Options command, Tools menu). Empty cells are not counted, but zero values are.

 

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]